﻿CREATE TABLE [dbo].[cms_article]
(
	[Id] UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
	[Title] nvarchar(256),
	[Content] text,
	[CreatedTime] datetime,
	[Creator] nvarchar(32),
	[CreatorText] nvarchar(32),
	[CategoryId] UNIQUEIDENTIFIER,
	[CategoryText] nvarchar(32),
	[Tags] nvarchar(255),
	[IsDeleted] bit,
	[IsEnabled] bit,
	[PublishedTime] datetime,
	[PublishedUrl] nvarchar(512), 
	[PublishedFile] nvarchar(512), 
    [Number] INT NOT NULL,
	[ModifiedTime] datetime NOT NULL, 
    [DisplayPublishedTime] DATETIME NULL
)
